package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class CourseDBTable {
    public static final String TABLE_NAME = "Course";

    public static final String ID = "course_id";
    public static final String START_YEAR = "start_year";
    public static final String END_YEAR = "end_year";

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        START_YEAR + " INTEGER NOT NULL, " +
                        END_YEAR + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }

}